package com.jiawa.langchain4j.mapper;

import com.jiawa.langchain4j.pojo.Reservation;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface ReservationMapper {
    //添加预约信息
    @Insert("INSERT INTO reservation (name, gender, phone, communication_time, province, estimated_score) " +  // 修改列名
            "VALUES (#{name}, #{gender}, #{phone}, #{communicationTime}, #{province}, #{estimatedScore})")
    void insert(Reservation reservation);
    //查询预约信息
    @Select("select * from reservation where phone=#{phone} ")
    Reservation findByPhone(String phone);

}
